The Database API > Database API functions > MMDB.showResultset() |
![]() ![]() ![]() |
Availability
Dreamweaver UltraDev 1.0
Description
Displays a dialog box with the results of executing the specified SQL statement. The dialog box displays a tabular grid, with the header reflecting the column information and data of the result set generated by the executed stored procedure. If the connection string or the SQL statement is invalid, an error appears. You can use this function to verify the validity of the SQL statement.
Arguments
connName
, SQLstatement
![]() |
connName is an UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source. |
![]() |
SQLstatement is the SQL SELECT statement. |
Returns
Nothing. This function returns an error if the SQL statement is invalid or if the connection string is wrong.
Example
The following code displays the results of the executed SQL statement:
MMDB.showResultset("EmpDB","Select EmpName,EmpFirstName,Age from¬ Employees")
![]() ![]() ![]() |